/*
 Navicat Premium Data Transfer

 Source Server         : 腾讯云数据库
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : bj-cynosdbmysql-grp-r4a9fj92.sql.tencentcdb.com:22059
 Source Schema         : welfare

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 12/02/2022 11:13:55
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_action_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_action_log`;
CREATE TABLE `sys_action_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) DEFAULT NULL COMMENT '日志名称',
  `type` tinyint(4) DEFAULT NULL COMMENT '日志类型',
  `ipaddr` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
  `clazz` varchar(255) DEFAULT NULL COMMENT '产生日志的类',
  `method` varchar(255) DEFAULT NULL COMMENT '产生日志的方法',
  `model` varchar(255) DEFAULT NULL COMMENT '产生日志的表',
  `record_id` bigint(20) DEFAULT NULL COMMENT '产生日志的数据id',
  `message` text COMMENT '日志消息',
  `create_date` datetime DEFAULT NULL COMMENT '记录时间',
  `oper_name` varchar(255) DEFAULT NULL COMMENT '产生日志的用户昵称',
  `oper_by` bigint(20) DEFAULT NULL COMMENT '产生日志的用户',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK32gm4dja0jetx58r9dc2uljiu` (`oper_by`) USING BTREE,
  CONSTRAINT `FK32gm4dja0jetx58r9dc2uljiu` FOREIGN KEY (`oper_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=262 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_action_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (245, '用户登录', 2, '223.104.41.246', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 12:43:47', '管理人员', 9);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (246, '用户登录', 2, '223.104.41.246', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 12:44:51', '管理人员', 9);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (247, '用户登录', 2, '121.29.77.251', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 12:47:06', '管理人员', 9);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (248, '用户登录', 2, '124.127.126.50', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 12:51:31', '管理员', 1);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (249, '用户登录', 2, '121.29.77.251', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 13:00:18', '管理员', 1);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (250, '用户登录', 2, '121.29.77.251', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 16:11:25', '管理员', 1);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (251, '用户登录', 2, '121.29.77.251', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 17:59:32', '管理员', 1);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (252, '用户登录', 2, '121.29.77.251', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 18:00:49', '小王', 7);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (253, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-11 23:53:41', '李老师', 3);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (254, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-12 00:08:50', '李老师', 3);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (255, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-12 09:41:13', '小王', 7);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (256, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录失败：[2022001]用户名或密码错误', '2022-02-12 09:41:17', '2022001', NULL);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (257, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-12 09:48:58', '小王', 7);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (258, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-12 09:49:45', '李老师', 3);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (259, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-12 09:53:35', '管理人员', 9);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (260, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-12 10:56:11', '管理人员', 9);
INSERT INTO `sys_action_log` (`id`, `name`, `type`, `ipaddr`, `clazz`, `method`, `model`, `record_id`, `message`, `create_date`, `oper_name`, `oper_by`) VALUES (261, '用户登录', 2, '127.0.0.1', 'com.linln.admin.system.controller.LoginController', 'login', NULL, NULL, '后台登录成功', '2022-02-12 10:56:59', '小王', 7);
COMMIT;

-- ----------------------------
-- Table structure for sys_assign
-- ----------------------------
DROP TABLE IF EXISTS `sys_assign`;
CREATE TABLE `sys_assign` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `create_date` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `num` int(10) DEFAULT NULL,
  `money` decimal(10,2) DEFAULT NULL,
  `deptname` varchar(50) DEFAULT NULL,
  `dept_id` int(10) DEFAULT NULL,
  `dept_pid` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKaddfmwi9qayac3pcqn06406lm` (`create_by`) USING BTREE,
  KEY `FKrm4e62gfswd37pql4h2q5j1gd` (`update_by`) USING BTREE,
  CONSTRAINT `sys_assign_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `sys_assign_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_assign
-- ----------------------------
BEGIN;
INSERT INTO `sys_assign` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `type`, `num`, `money`, `deptname`, `dept_id`, `dept_pid`) VALUES (6, '2020-03-14 21:01:17', '', 1, '2020-03-14 21:01:56', 1, 4, '低保', 90, 1000.00, '测试一县', 2, 1);
INSERT INTO `sys_assign` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `type`, `num`, `money`, `deptname`, `dept_id`, `dept_pid`) VALUES (7, '2020-03-14 21:01:56', '', 1, '2020-03-14 22:08:04', 4, 3, '低保', 7, 1000.00, '白云村', 3, 2);
INSERT INTO `sys_assign` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `type`, `num`, `money`, `deptname`, `dept_id`, `dept_pid`) VALUES (8, '2020-03-15 17:53:10', '', 1, '2020-03-15 18:00:13', 1, 3, '临时救助', 10, 100.00, '测试一县', 2, 1);
INSERT INTO `sys_assign` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `type`, `num`, `money`, `deptname`, `dept_id`, `dept_pid`) VALUES (9, '2020-03-15 18:00:13', '', 3, '2020-03-15 18:02:04', 3, 4, '临时救助', 0, 100.00, '白云村', 3, 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(255) DEFAULT NULL COMMENT '部门名称',
  `pid` bigint(20) DEFAULT NULL COMMENT '父级ID',
  `pids` varchar(255) DEFAULT NULL COMMENT '所有父级编号',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKifwd1h4ciusl3nnxrpfpv316u` (`create_by`) USING BTREE,
  KEY `FK83g45s1cjqqfpifhulqhv807m` (`update_by`) USING BTREE,
  CONSTRAINT `FK83g45s1cjqqfpifhulqhv807m` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKifwd1h4ciusl3nnxrpfpv316u` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (1, '大学生', 0, '[0]', 2, '', '2018-12-02 17:41:23', '2022-01-22 18:00:30', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (2, '大学一年级', 1, '[0],[1]', 1, '', '2018-12-02 17:51:04', '2022-01-22 18:00:47', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (3, '物理学专业', 2, '[0],[1],[2]', 1, '', '2018-12-02 17:51:42', '2022-01-22 18:02:58', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (4, '大学二年级', 1, '[0],[1]', 2, '', '2018-12-02 17:51:55', '2022-01-22 18:01:06', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (5, '生物学专业', 2, '[0],[1],[2]', 2, '', '2018-12-02 17:52:07', '2022-01-22 18:03:22', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (6, '白云乡村民', 3, '[0],[1],[2],[3]', 1, '', '2020-03-14 18:06:03', '2022-01-22 18:05:01', 1, 1, 3);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (7, '教职工', 0, '[0]', 1, '用于存放新注册的用户', '2020-03-15 17:19:55', '2022-01-22 18:00:18', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (8, '大学三年级', 1, '[0],[1]', 3, '', '2022-01-22 18:01:26', '2022-01-22 18:01:26', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (9, '大学四年级', 1, '[0],[1]', 4, '', '2022-01-22 18:01:46', '2022-01-22 18:01:46', 1, 1, 1);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (10, 'xx局', 0, '[0]', 3, '', '2022-01-23 23:21:08', '2022-01-30 20:12:36', 1, 1, 3);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (11, 'xx科室', 13, '[0],[10],[13]', 1, '', '2022-01-23 23:21:26', '2022-01-30 20:12:36', 1, 1, 3);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (12, 'xx2科室', 13, '[0],[10],[13]', 2, '', '2022-01-23 23:31:59', '2022-01-30 20:12:36', 1, 1, 3);
INSERT INTO `sys_dept` (`id`, `title`, `pid`, `pids`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (13, '李副局', 10, '[0],[10]', 3, '', '2022-01-23 23:38:20', '2022-01-30 20:12:36', 1, 1, 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(255) DEFAULT NULL COMMENT '字典名称',
  `name` varchar(255) DEFAULT NULL COMMENT '字典键名',
  `type` tinyint(4) DEFAULT NULL COMMENT '字典类型',
  `value` text COMMENT '字典键值',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKag4shuprf2tjot9i1mhh37kk6` (`create_by`) USING BTREE,
  KEY `FKoyng5jlifhsme0gc1lwiub0lr` (`update_by`) USING BTREE,
  CONSTRAINT `FKag4shuprf2tjot9i1mhh37kk6` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKoyng5jlifhsme0gc1lwiub0lr` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (1, '数据状态', 'DATA_STATUS', 2, '1:正常,2:冻结,3:删除', '', '2019-10-05 16:03:11', '2020-03-14 10:00:16', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (2, '字典类型', 'DICT_TYPE', 2, '2:键值对', '', '2019-10-05 20:08:55', '2019-01-17 23:39:23', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (3, '用户性别', 'USER_SEX', 2, '1:男,2:女', '', '2019-10-05 20:12:32', '2018-10-05 20:12:32', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (4, '菜单类型', 'MENU_TYPE', 2, '1:目录,2:菜单,3:按钮', '', '2019-10-05 20:24:57', '2019-11-06 20:08:46', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (5, '搜索栏状态', 'SEARCH_STATUS', 2, '1:正常,2:冻结', '', '2019-10-05 20:25:45', '2019-02-26 00:34:34', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (6, '日志类型', 'LOG_TYPE', 2, '1:业务,2:登录,3:系统', '', '2019-10-05 20:28:47', '2019-02-26 00:31:43', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (7, '用户审核状态', 'USER_AUDIT_STATUS', 2, '1:审核通过,2:正在审核,0:审核未通过', '', '2020-03-14 10:03:53', '2020-03-14 11:38:54', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (8, '请假审核', 'RURAL_AUDIT_STATUS', 2, '2:待审核,1:审核通过,0:审核未通过', '', '2020-03-14 10:14:09', '2022-01-23 21:09:21', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (9, '销假审核', 'COUNTY_ADUIT_STATUS', 2, '1:待销假,4:待审核,5:审核通过', '', '2020-03-14 10:15:09', '2022-01-23 21:14:30', 1, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (10, '申请表类型', 'COS_TYPE', 2, '1申请表:1申请表,2申请表:2申请表,3申请表:3申请表,4申请表:4申请表', '', '2020-03-14 22:36:28', '2022-01-23 21:10:09', 4, 1, 1);
INSERT INTO `sys_dict` (`id`, `title`, `name`, `type`, `value`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (11, '销假审批管理', 'CANCEL_ADUIT_STATUS', 2, '4:待审批,5:审批通过', '', '2022-01-23 21:19:12', '2022-01-23 21:19:12', 1, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `path` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `mime` varchar(255) DEFAULT NULL COMMENT 'MIME文件类型',
  `size` bigint(20) DEFAULT NULL COMMENT '文件大小',
  `md5` varchar(255) DEFAULT NULL COMMENT 'MD5值',
  `sha1` varchar(255) DEFAULT NULL COMMENT 'SHA1值',
  `create_by` bigint(20) DEFAULT NULL COMMENT '上传者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKkkles8yp0a156p4247cc22ovn` (`create_by`) USING BTREE,
  CONSTRAINT `FKkkles8yp0a156p4247cc22ovn` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_file
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `pid` bigint(20) DEFAULT NULL COMMENT '父级编号',
  `pids` varchar(255) DEFAULT NULL COMMENT '所有父级编号',
  `url` varchar(255) DEFAULT NULL COMMENT 'URL地址',
  `perms` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `type` tinyint(4) DEFAULT NULL COMMENT '类型（1:一级菜单,2:子级菜单,3:不是菜单）',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKoxg2hi96yr9pf2m0stjomr3we` (`create_by`) USING BTREE,
  KEY `FKsiko0qcr8ddamvrxf1tk4opgc` (`update_by`) USING BTREE,
  CONSTRAINT `FKoxg2hi96yr9pf2m0stjomr3we` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKsiko0qcr8ddamvrxf1tk4opgc` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (1, '菜单管理', 2, '[0],[2]', '/system/menu/index', 'system:menu:index', '', 2, 3, '', '2018-09-29 00:02:10', '2019-02-24 16:10:40', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (2, '系统管理', 0, '[0]', '#', '#', 'fa fa-cog', 1, 2, '', '2018-09-29 00:05:50', '2019-02-27 21:34:56', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (3, '添加', 1, '[0],[2],[1]', '/system/menu/add', 'system:menu:add', '', 3, 1, '', '2018-09-29 00:06:57', '2019-02-24 16:12:59', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (4, '角色管理', 173, '[0],[173]', '/system/role/index', 'system:role:index', '', 2, 3, '', '2018-09-29 00:08:14', '2020-03-14 22:46:19', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (5, '添加', 4, '[0],[2],[4]', '/system/role/add', 'system:role:add', '', 3, 1, '', '2018-09-29 00:09:04', '2019-02-24 16:12:04', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (6, '主页', 0, '[0]', '/index', 'index', 'layui-icon layui-icon-home', 1, 1, '', '2018-09-29 00:09:56', '2019-02-27 21:34:56', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (7, '帐号管理', 173, '[0],[173]', '/system/user/index', 'system:user:index', '', 2, 1, '', '2018-09-29 00:43:50', '2022-01-22 21:38:26', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (8, '编辑', 1, '[0],[2],[1]', '/system/menu/edit', 'system:menu:edit', '', 3, 2, '', '2018-09-29 00:57:33', '2019-02-24 16:13:05', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (9, '详细', 1, '[0],[2],[1]', '/system/menu/detail', 'system:menu:detail', '', 3, 3, '', '2018-09-29 01:03:00', '2019-02-24 16:13:12', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (10, '修改状态', 1, '[0],[2],[1]', '/system/menu/status', 'system:menu:status', '', 3, 4, '', '2018-09-29 01:03:43', '2019-02-24 16:13:21', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (11, '编辑', 4, '[0],[2],[4]', '/system/role/edit', 'system:role:edit', '', 3, 2, '', '2018-09-29 01:06:13', '2019-02-24 16:12:10', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (12, '授权', 4, '[0],[2],[4]', '/system/role/auth', 'system:role:auth', '', 3, 3, '', '2018-09-29 01:06:57', '2019-02-24 16:12:17', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (13, '详细', 4, '[0],[2],[4]', '/system/role/detail', 'system:role:detail', '', 3, 4, '', '2018-09-29 01:08:00', '2019-02-24 16:12:24', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (14, '修改状态', 4, '[0],[2],[4]', '/system/role/status', 'system:role:status', '', 3, 5, '', '2018-09-29 01:08:22', '2019-02-24 16:12:43', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (15, '编辑', 7, '[0],[2],[7]', '/system/user/edit', 'system:user:edit', '', 3, 2, '', '2018-09-29 21:17:17', '2019-02-24 16:11:03', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (16, '添加', 7, '[0],[2],[7]', '/system/user/add', 'system:user:add', '', 3, 1, '', '2018-09-29 21:17:58', '2019-02-24 16:10:28', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (17, '修改密码', 7, '[0],[2],[7]', '/system/user/pwd', 'system:user:pwd', '', 3, 3, '', '2018-09-29 21:19:40', '2019-02-24 16:11:11', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (18, '权限分配', 7, '[0],[2],[7]', '/system/user/role', 'system:user:role', '', 3, 4, '', '2018-09-29 21:20:35', '2019-02-24 16:11:18', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (19, '详细', 7, '[0],[2],[7]', '/system/user/detail', 'system:user:detail', '', 3, 5, '', '2018-09-29 21:21:00', '2019-02-24 16:11:26', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (20, '修改状态', 7, '[0],[2],[7]', '/system/user/status', 'system:user:status', '', 3, 6, '', '2018-09-29 21:21:18', '2019-02-24 16:11:35', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (21, '字典管理', 2, '[0],[2]', '/system/dict/index', 'system:dict:index', '', 2, 5, '', '2018-10-05 00:55:52', '2019-02-24 16:14:24', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (22, '字典添加', 21, '[0],[2],[21]', '/system/dict/add', 'system:dict:add', '', 3, 1, '', '2018-10-05 00:56:26', '2019-02-24 16:14:10', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (23, '字典编辑', 21, '[0],[2],[21]', '/system/dict/edit', 'system:dict:edit', '', 3, 2, '', '2018-10-05 00:57:08', '2019-02-24 16:14:34', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (24, '字典详细', 21, '[0],[2],[21]', '/system/dict/detail', 'system:dict:detail', '', 3, 3, '', '2018-10-05 00:57:42', '2019-02-24 16:14:41', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (25, '修改状态', 21, '[0],[2],[21]', '/system/dict/status', 'system:dict:status', '', 3, 4, '', '2018-10-05 00:58:27', '2019-02-24 16:14:49', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (26, '行为日志', 2, '[0],[2]', '/system/actionLog/index', 'system:actionLog:index', '', 2, 6, '', '2018-10-14 16:52:01', '2019-02-27 21:34:15', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (27, '日志详细', 26, '[0],[2],[26]', '/system/actionLog/detail', 'system:actionLog:detail', '', 3, 1, '', '2018-10-14 21:07:11', '2019-02-27 21:34:15', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (28, '日志删除', 26, '[0],[2],[26]', '/system/actionLog/delete', 'system:actionLog:delete', '', 3, 2, '', '2018-10-14 21:08:17', '2019-02-27 21:34:15', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (30, '开发中心', 0, '[0]', '#', '#', 'fa fa-gavel', 1, 4, '', '2018-10-19 16:38:23', '2020-03-14 23:03:11', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (31, '代码生成', 30, '[0],[30]', '/dev/code', '#', '', 2, 1, '', '2018-10-19 16:39:04', '2020-03-14 23:03:11', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (125, '表单构建', 30, '[0],[30]', '/dev/build', '#', '', 2, 2, '', '2018-11-25 16:12:23', '2020-03-14 23:03:11', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (136, '组织架构', 173, '[0],[173]', '/system/dept/index', 'system:dept:index', '', 2, 2, '', '2018-12-02 16:33:23', '2022-01-22 18:07:16', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (137, '添加', 136, '[0],[2],[136]', '/system/dept/add', 'system:dept:add', '', 3, 1, '', '2018-12-02 16:33:23', '2019-02-24 16:13:34', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (138, '编辑', 136, '[0],[2],[136]', '/system/dept/edit', 'system:dept:edit', '', 3, 2, '', '2018-12-02 16:33:23', '2019-02-24 16:13:42', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (139, '详细', 136, '[0],[2],[136]', '/system/dept/detail', 'system:dept:detail', '', 3, 3, '', '2018-12-02 16:33:23', '2019-02-24 16:13:49', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (140, '改变状态', 136, '[0],[2],[136]', '/system/dept/status', 'system:dept:status', '', 3, 4, '', '2018-12-02 16:33:23', '2019-02-24 16:13:57', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (146, '数据接口', 30, '[0],[30]', '/dev/swagger', '#', '', 2, 3, '', '2018-12-09 21:11:11', '2020-03-14 23:03:11', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (147, '请假申请', 170, '[0],[170]', '/welfare/welfare/index', 'welfare:welfare:index', '', 2, 2, '', '2020-03-14 00:01:08', '2022-01-23 21:05:21', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (148, '添加', 147, '[0],[2],[147]', '/welfare/welfare/add', 'welfare:welfare:add', NULL, 3, 1, NULL, '2020-03-14 00:01:08', '2022-01-23 21:01:54', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (149, '编辑', 147, '[0],[2],[147]', '/welfare/welfare/edit', 'welfare:welfare:edit', NULL, 3, 1, NULL, '2020-03-14 00:01:08', '2022-01-23 21:01:54', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (150, '详细', 147, '[0],[2],[147]', '/welfare/welfare/detail', 'welfare:welfare:detail', NULL, 3, 1, NULL, '2020-03-14 00:01:08', '2022-01-23 21:01:54', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (151, '修改状态', 147, '[0],[2],[147]', '/welfare/welfare/status', 'welfare:welfare:status', NULL, 3, 1, NULL, '2020-03-14 00:01:08', '2022-01-23 21:01:54', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (157, '请假审批', 171, '[0],[171]', '/welfare/audit/index', 'welfare:audit:index', '', 2, 1, '', '2020-03-14 17:33:00', '2022-01-23 17:19:13', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (158, '县级申请审核', 171, '[0],[171]', '/welfare/audit2/index', 'welfare:audit2:index', '', 2, 3, '', '2020-03-14 19:56:09', '2022-01-23 21:01:45', 3, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (159, '福利分配', 172, '[0],[172]', '/welfare/assign/index', 'welfare:assign:index', '', 2, 1, '', '2020-03-14 20:22:06', '2022-01-30 20:20:44', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (160, '添加福利', 159, '[0],[172],[159]', '/welfare/assign/add', 'welfare:assign:add', '', 3, 2, '', '2020-03-14 20:22:06', '2022-01-30 20:20:44', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (161, '分配福利', 159, '[0],[2],[159]', '/welfare/assign/edit', 'welfare:assign:edit', '', 3, 1, '', '2020-03-14 20:22:06', '2022-01-30 20:21:05', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (162, '详细', 159, '[0],[159]', '/welfare/assign/detail', 'welfare:assign:detail', NULL, 3, 3, NULL, '2020-03-14 20:22:06', '2022-01-30 20:21:11', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (163, '修改状态', 159, '[0],[159]', '/welfare/assign/status', 'welfare:assign:status', NULL, 3, 1, NULL, '2020-03-14 20:22:06', '2020-03-14 21:06:09', 1, 3, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (164, '个人信息管理', 171, '[0],[171]', '/welfare/self/index', 'welfare:self:index', '', 2, 4, '', '2020-03-14 21:30:27', '2022-01-30 20:20:51', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (165, '添加', 164, '[0],[2],[164]', '/welfare/self/add', 'welfare:self:add', NULL, 3, 1, NULL, '2020-03-14 21:30:27', '2022-01-30 20:20:51', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (166, '编辑', 164, '[0],[2],[164]', '/welfare/self/edit', 'welfare:self:edit', NULL, 3, 1, NULL, '2020-03-14 21:30:27', '2022-01-30 20:20:51', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (167, '详细', 164, '[0],[2],[164]', '/welfare/self/detail', 'welfare:self:detail', NULL, 3, 1, NULL, '2020-03-14 21:30:27', '2022-01-30 20:20:51', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (168, '修改状态', 164, '[0],[2],[164]', '/welfare/self/status', 'welfare:self:status', NULL, 3, 1, NULL, '2020-03-14 21:30:27', '2022-01-30 20:20:51', 1, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (169, '我的信息', 170, '[0],[170]', '/welfare/self/my', 'welfare:self:my', '', 2, 1, '', '2020-03-14 21:51:20', '2022-01-23 21:04:37', 4, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (170, '我的功能', 0, '[0]', '#', '#', 'fa fa-user', 1, 6, '', '2020-03-14 22:41:49', '2020-03-14 22:48:58', 4, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (171, '审批管理', 0, '[0]', '#', '#', 'fa fa-gavel', 1, 5, '', '2020-03-14 22:43:03', '2020-03-14 22:48:46', 4, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (172, '福利分配', 0, '[0]', '#', '#', 'fa fa-gg', 1, 7, '', '2020-03-14 22:43:51', '2022-01-30 20:20:44', 4, 1, 3);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (173, '权限管理', 0, '[0]', '#', '#', 'fa fa-lock', 1, 3, '', '2020-03-14 22:45:43', '2020-03-14 22:48:31', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (174, '销假申请', 170, '[0],[170]', '/welfare/welfare/cancel', 'welfare:welfare:cancel', '', 2, 1, '', '2022-01-23 20:22:45', '2022-01-23 21:05:30', 1, 1, 1);
INSERT INTO `sys_menu` (`id`, `title`, `pid`, `pids`, `url`, `perms`, `icon`, `type`, `sort`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (175, '销假审批', 171, '[0],[171]', '/welfare/audit/cancel', 'welfare:audit:cancel', '', 2, 2, '', '2022-01-23 21:00:56', '2022-01-23 21:00:56', 1, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(255) DEFAULT NULL COMMENT '角色名称（中文名）',
  `name` varchar(255) DEFAULT NULL COMMENT '标识名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '创建用户',
  `update_by` bigint(20) DEFAULT NULL COMMENT '更新用户',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKdkwvv0rm6j3d5l6hwsy2dplol` (`create_by`) USING BTREE,
  KEY `FKrouqqi3f2bgc5o83wdstlh6q4` (`update_by`) USING BTREE,
  CONSTRAINT `FKdkwvv0rm6j3d5l6hwsy2dplol` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKrouqqi3f2bgc5o83wdstlh6q4` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (1, '管理员', 'admin', '', '2019-09-29 00:12:40', '2022-01-30 20:33:36', 1, 1, 1);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (2, '省级管理员', 'group', '', '2019-09-30 16:04:32', '2020-03-14 22:57:14', 1, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (3, '县级管理员', 'group1', '', '2019-09-30 16:24:20', '2020-03-15 17:51:23', 1, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (4, '村级管理员', 'cunzhishu', '', '2020-03-14 21:04:58', '2020-03-15 17:51:31', 3, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (5, '普通村民', 'cunming', '', '2020-03-14 21:56:48', '2020-03-14 22:54:40', 4, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (6, '学生', 'student', '', '2022-01-22 18:08:56', '2022-01-30 20:42:43', 1, 1, 1);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (7, '导员', 'teacher', '', '2022-01-22 18:09:09', '2022-01-30 20:14:52', 1, 1, 1);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (8, '局长', 'director', '', '2022-01-23 23:23:26', '2022-01-23 23:23:26', 1, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (9, '分管领导', 'leader', '', '2022-01-23 23:29:58', '2022-01-23 23:29:58', 1, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (10, '科室负责人', 'section', '', '2022-01-23 23:30:21', '2022-01-23 23:30:21', 1, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (11, '科室副职', 'section2', '', '2022-01-23 23:31:06', '2022-01-23 23:31:06', 1, 1, 3);
INSERT INTO `sys_role` (`id`, `title`, `name`, `remark`, `create_date`, `update_date`, `create_by`, `update_by`, `status`) VALUES (12, '一般员工', 'staff', '', '2022-01-23 23:31:28', '2022-01-23 23:31:28', 1, 1, 3);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL,
  `menu_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE,
  KEY `FKf3mud4qoc7ayew8nml4plkevo` (`menu_id`) USING BTREE,
  CONSTRAINT `FKf3mud4qoc7ayew8nml4plkevo` FOREIGN KEY (`menu_id`) REFERENCES `sys_menu` (`id`),
  CONSTRAINT `FKkeitxsgxwayackgqllio4ohn5` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 2);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 4);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 5);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 6);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 6);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 6);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 7);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 7);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 11);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 12);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 13);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 14);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 15);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 15);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 16);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 16);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 17);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 17);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 18);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 18);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 19);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 19);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 20);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 20);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 26);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 27);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 28);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 136);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 136);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 137);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 137);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 138);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 138);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 139);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 139);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 140);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 140);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 147);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 148);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 149);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 150);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 151);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 157);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 170);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 171);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (1, 173);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 173);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (6, 174);
INSERT INTO `sys_role_menu` (`role_id`, `menu_id`) VALUES (7, 175);
COMMIT;

-- ----------------------------
-- Table structure for sys_self
-- ----------------------------
DROP TABLE IF EXISTS `sys_self`;
CREATE TABLE `sys_self` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `create_date` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  `work` varchar(255) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `area` varchar(255) NOT NULL,
  `number` varchar(50) DEFAULT NULL,
  `gam` varchar(255) DEFAULT NULL,
  `labor` varchar(255) DEFAULT NULL,
  `money` decimal(10,2) DEFAULT NULL,
  `card` varchar(255) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `user_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKaddfmwi9qayac3pcqn06406lm` (`create_by`) USING BTREE,
  KEY `FKrm4e62gfswd37pql4h2q5j1gd` (`update_by`) USING BTREE,
  CONSTRAINT `sys_self_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `sys_self_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_self
-- ----------------------------
BEGIN;
INSERT INTO `sys_self` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `work`, `account`, `name`, `area`, `number`, `gam`, `labor`, `money`, `card`, `bank`, `user_id`) VALUES (3, '2020-03-14 16:38:43', '', 3, '2020-03-14 16:48:59', 1, 1, 'A类型1584175739326', '内蒙', '暂时', '内蒙', '10000', '未婚', '有劳动能力', 1000.00, '111', '11', 1);
INSERT INTO `sys_self` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `work`, `account`, `name`, `area`, `number`, `gam`, `labor`, `money`, `card`, `bank`, `user_id`) VALUES (4, '2020-03-14 17:18:41', '2', 0, '2020-03-14 19:54:31', 1, 3, 'B1584177520975', '内蒙', 'rain', '内蒙', '1233', '未婚', NULL, 1000.00, '12', '22', 1);
INSERT INTO `sys_self` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `work`, `account`, `name`, `area`, `number`, `gam`, `labor`, `money`, `card`, `bank`, `user_id`) VALUES (5, '2020-03-14 22:06:09', '', 1, '2020-03-15 18:02:04', 5, 4, '', '123', '123', '', '', '', '', 1800.00, '', '', 5);
INSERT INTO `sys_self` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `work`, `account`, `name`, `area`, `number`, `gam`, `labor`, `money`, `card`, `bank`, `user_id`) VALUES (6, '2020-03-15 17:39:27', '', 1, '2020-03-15 17:39:27', 8, 8, '', '内蒙', '', '', '', '未婚', '有劳动能力', NULL, '', '', 8);
INSERT INTO `sys_self` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `work`, `account`, `name`, `area`, `number`, `gam`, `labor`, `money`, `card`, `bank`, `user_id`) VALUES (7, '2020-03-15 17:40:53', '', 1, '2020-03-15 18:01:36', 7, 4, '', '内蒙', '', '', '', '未婚', '有劳动能力', 1200.00, '', '', 7);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `nickname` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `password` char(64) DEFAULT NULL COMMENT '密码',
  `salt` varchar(255) DEFAULT NULL COMMENT '密码盐',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `picture` varchar(255) DEFAULT NULL COMMENT '头像',
  `sex` tinyint(4) DEFAULT NULL COMMENT '性别（1:男,2:女）',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `phone` varchar(255) DEFAULT NULL COMMENT '电话号码',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
  `number` varchar(50) DEFAULT NULL COMMENT '身份证号码',
  `nation` varchar(10) DEFAULT NULL COMMENT '民族',
  `address` varchar(255) DEFAULT NULL COMMENT '家庭住址',
  `leavenum` double DEFAULT NULL,
  `workdate` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKb3pkx0wbo6o8i8lj0gxr37v1n` (`dept_id`) USING BTREE,
  CONSTRAINT `FKb3pkx0wbo6o8i8lj0gxr37v1n` FOREIGN KEY (`dept_id`) REFERENCES `sys_dept` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (1, 'admin', '管理员', '5fa04c0758ae596e2a93cd2802640693a5b08bdfacd4307abce323c85e481154', '7rl2t9', 7, NULL, 1, '10086@163.com', '18888888888', '', '2019-08-09 23:00:03', '2022-01-30 20:34:39', 1, '100000', '汉族', '中国', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (2, '1003', '张老师', '28bfc4f19b0d4b8a40018faf9aec4ad9db5491082dda439040b1c35ff8c533a7', 'gzNkXt', 7, NULL, 2, '1008612@qq.com', '18888888888', '', '2019-09-30 16:25:22', '2022-01-22 21:31:56', 1, '', '', '', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (3, '1001', '李老师', '1fa5bdabb1391bbfd6059d01a574e714f2261b48576dcc83a333fb88f945b7ea', 'XUT3i2', 2, NULL, 1, '123@163.com', '18888888888', '', '2020-03-14 18:03:43', '2022-01-23 21:06:18', 1, '100000', '中国', '中国', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (4, '1002', '王老师', '3b01f9ccd17394d3de16fe7ffc6c946e658f45b33f681c583e012470d92f1489', 'EeemfO', 7, NULL, 1, '123@163.com', '18888888888', '', '2020-03-14 19:59:39', '2022-01-22 21:31:47', 1, '100000', '汉族', '中国', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (5, '2022003', '小张', '40f8f4eb5932c4fc29314ab87911be0b9f3deaf44d9262286ac45a3b98a885c5', 'IWtDWB', 5, NULL, 1, '123@163.com', '18888888888', '', '2020-03-14 21:45:29', '2022-01-22 21:15:46', 1, '100000', '中国', '中国', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (7, '2022001', '小王', '745e4ea370ce70cc5cdc37b5996db7d70d3da0722e809c67ed57a41e99bdefe7', '6MYtyb', 5, NULL, 1, '123@163.com', '18888888888', '', '2020-03-15 17:38:15', '2022-01-30 20:42:59', 1, '', '', '', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (8, '2022002', '小雨', 'e678dda3884702c0730a65e06437aaf11d8b88ce2526e7e5110f8144132ef5de', 'CyFwTV', 3, NULL, 1, '', '18888888888', '', '2020-03-15 17:38:59', '2022-01-30 20:20:14', 1, '', '', '', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (9, 'root', '管理人员', 'eb88be7f1da302d478de04bc1b0adc1980c916b15aedd380d43db3eb14be4dbd', 'kJO9w6', 7, NULL, 1, '', '', '', '2022-01-30 20:36:31', '2022-01-30 20:38:43', 1, '', '', '', NULL, NULL);
INSERT INTO `sys_user` (`id`, `username`, `nickname`, `password`, `salt`, `dept_id`, `picture`, `sex`, `email`, `phone`, `remark`, `create_date`, `update_date`, `status`, `number`, `nation`, `address`, `leavenum`, `workdate`) VALUES (10, 'asdasd', 'xiaozhang', 'dcacd62d2e211d4b0848ed436f6bb47d639947efa0b47b694c1678d05475eecd', 'KVYq2F', 2, NULL, 1, '', '1234567777', '', '2022-02-11 10:46:11', '2022-02-11 10:46:11', 1, '', '', '', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `user_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
  KEY `FKhh52n8vd4ny9ff4x9fb8v65qx` (`role_id`) USING BTREE,
  CONSTRAINT `FKb40xxfch70f5qnyfw8yme1n1s` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKhh52n8vd4ny9ff4x9fb8v65qx` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (1, 1);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (9, 1);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (7, 6);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (8, 6);
INSERT INTO `sys_user_role` (`user_id`, `role_id`) VALUES (3, 7);
COMMIT;

-- ----------------------------
-- Table structure for sys_welfare
-- ----------------------------
DROP TABLE IF EXISTS `sys_welfare`;
CREATE TABLE `sys_welfare` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `create_date` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `account` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `area` varchar(255) NOT NULL,
  `number` varchar(50) DEFAULT NULL,
  `gam` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `labor` varchar(255) DEFAULT NULL,
  `num` varchar(20) DEFAULT NULL,
  `money` decimal(10,2) DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `end_date` varchar(255) DEFAULT NULL,
  `card` varchar(255) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `cos` varchar(50) DEFAULT NULL,
  `user_id` int(10) DEFAULT NULL,
  `move` int(10) DEFAULT NULL,
  `changeleader` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKaddfmwi9qayac3pcqn06406lm` (`create_by`) USING BTREE,
  KEY `FKrm4e62gfswd37pql4h2q5j1gd` (`update_by`) USING BTREE,
  CONSTRAINT `sys_welfare_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `sys_welfare_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_welfare
-- ----------------------------
BEGIN;
INSERT INTO `sys_welfare` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `code`, `account`, `name`, `area`, `number`, `gam`, `type`, `labor`, `num`, `money`, `start_date`, `end_date`, `card`, `bank`, `cos`, `user_id`, `move`, `changeleader`) VALUES (3, '2020-03-14 16:38:43', '', 3, '2020-03-14 16:48:59', 1, 1, 'A类型1584175739326', '内蒙', '暂时', '内蒙', '10000', '未婚', 'A类型', '有劳动能力', '1', 1000.00, NULL, NULL, '111', '11', NULL, 1, 2, NULL);
INSERT INTO `sys_welfare` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `code`, `account`, `name`, `area`, `number`, `gam`, `type`, `labor`, `num`, `money`, `start_date`, `end_date`, `card`, `bank`, `cos`, `user_id`, `move`, `changeleader`) VALUES (5, '2020-03-15 17:43:26', '', 1, '2022-01-23 20:12:27', 7, 7, 'DBA1584265405860', '内蒙', '三三', '内蒙', '100000', '已婚', 'A', '有劳动能力', '1', 1000.00, '2020-03-23 00:00:00', '2020-03-23 00:00:00', '10002', '11', '病假', 7, 0, NULL);
INSERT INTO `sys_welfare` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `code`, `account`, `name`, `area`, `number`, `gam`, `type`, `labor`, `num`, `money`, `start_date`, `end_date`, `card`, `bank`, `cos`, `user_id`, `move`, `changeleader`) VALUES (6, '2022-01-23 12:58:37', '11444', 1, '2022-01-23 20:12:14', 7, 7, 'DBnull1642913917481', NULL, '123', '目的地', '111', NULL, NULL, NULL, NULL, NULL, '2022-01-24 00:00:00', '2022-01-24 00:00:00', '11111', NULL, '事假', 7, 0, NULL);
INSERT INTO `sys_welfare` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `code`, `account`, `name`, `area`, `number`, `gam`, `type`, `labor`, `num`, `money`, `start_date`, `end_date`, `card`, `bank`, `cos`, `user_id`, `move`, `changeleader`) VALUES (7, '2022-01-23 15:23:37', '11234', 5, '2022-01-23 21:28:40', 7, 3, '1642922660680', NULL, '123', '目的地', 'mrrp', NULL, NULL, NULL, NULL, NULL, '2022-01-23 00:00:00', '2022-01-24 00:00:00', '11111', NULL, '事假', 7, 1, NULL);
INSERT INTO `sys_welfare` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `code`, `account`, `name`, `area`, `number`, `gam`, `type`, `labor`, `num`, `money`, `start_date`, `end_date`, `card`, `bank`, `cos`, `user_id`, `move`, `changeleader`) VALUES (8, '2022-01-31 17:03:40', '555', 5, '2022-01-31 17:14:43', 7, 3, '1643619820185', NULL, 'test', '3434', '111', NULL, NULL, NULL, NULL, NULL, '2022-01-31T17:03', '2022-01-31T17:03', '123', NULL, '事假', 7, 1, NULL);
INSERT INTO `sys_welfare` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `code`, `account`, `name`, `area`, `number`, `gam`, `type`, `labor`, `num`, `money`, `start_date`, `end_date`, `card`, `bank`, `cos`, `user_id`, `move`, `changeleader`) VALUES (9, '2022-02-11 10:47:30', '', 1, '2022-02-11 10:50:29', 7, 3, '1644547649836', NULL, '学生请假', 'shijiazhuang', '123', NULL, NULL, NULL, NULL, NULL, '2022-02-11T12:47', '2022-02-18T10:47', '', NULL, '事假', 7, 1, NULL);
INSERT INTO `sys_welfare` (`id`, `create_date`, `remark`, `status`, `update_date`, `create_by`, `update_by`, `code`, `account`, `name`, `area`, `number`, `gam`, `type`, `labor`, `num`, `money`, `start_date`, `end_date`, `card`, `bank`, `cos`, `user_id`, `move`, `changeleader`) VALUES (10, '2022-02-12 09:42:25', '123', 1, '2022-02-12 09:50:09', 7, 3, '1644630144474', NULL, 'liu', '好的', '123', NULL, NULL, NULL, NULL, NULL, '2022-02-12T09:42', '2022-02-12T21:42', '123123', NULL, '事假', 7, 1, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
